I recently started coding in c #(in may this year) and well I find it best to learn by working with code. this application http://www.c-sharpcorner.com/UploadFile/satisharveti/ActiveApplicationWatcher01252007024921AM/ActiveApplicationWatcher.aspx. I am trying to recreate it however mine will be saving the information into an sql database(new at this as well). I am having some coding problems though as it does not do what I expect it to do. THis is the main code I am using.

private void GetTotalTimer()
        {
            DateTime now = DateTime.Now;
            IntPtr hwnd = APIFunc.getforegroundWindow();
            Int32 pid = APIFunc.GetWindowProcessID(hwnd);
            Process p = Process.GetProcessById(pid);

            appName = p.ProcessName;
            const int nChars = 256;
            int handle = 0;
            StringBuilder Buff = new StringBuilder(nChars);
            handle = GetForegroundWindow();
            appltitle = APIFunc.ActiveApplTitle().Trim().Replace("\0", "");

            //if (GetWindowText(handle, Buff, nChars) > 0)
            //{
            //    string strbuff = Buff.ToString();

            //    StrWindow = strbuff;

                #region insert statement
                try
                {
                    if (Conn.State == ConnectionState.Closed)
                    {
                        Conn.Open();
                    }
                    if (Conn.State == ConnectionState.Open)
                    {
                        SqlCommand com = new SqlCommand("Select top 1 [Window Title] From TimerLogs ORDER BY [Time of Event] DESC", Conn);
                        SqlDataReader reader = com.ExecuteReader();
                        startTime = DateTime.Now;
                        string time = now.ToString();
                        if (!reader.HasRows)
                        {
                            reader.Close();


                            cmd = new SqlCommand("insert into [TimerLogs] values(@time,@appName,@appltitle,@Elapsed_Time,@userName)", Conn);
                            cmd.Parameters.AddWithValue("@time", time);
                            cmd.Parameters.AddWithValue("@appName", appName);
                            cmd.Parameters.AddWithValue("@appltitle", appltitle);
                            cmd.Parameters.AddWithValue("@Elapsed_Time", blank.ToString());
                            cmd.Parameters.AddWithValue("@userName", userName);
                            cmd.ExecuteNonQuery();
                            Conn.Close();
                        }
                        else if(reader.HasRows)
                        {
                            reader.Read();
                            if (appltitle != reader.ToString())
                            {
                                reader.Close();
                                endTime = DateTime.Now;
                                appduration = endTime.Subtract(startTime);

                                cmd = new SqlCommand("insert into [TimerLogs] values (@time,@appName,@appltitle,@Elapsed_Time,@userName)", Conn);
                                cmd.Parameters.AddWithValue("@time", time);
                                cmd.Parameters.AddWithValue("@appName", appName);
                                cmd.Parameters.AddWithValue("@appltitle", appltitle);
                                cmd.Parameters.AddWithValue("@Elapsed_Time", appduration.ToString());
                                cmd.Parameters.AddWithValue("@userName", userName);
                                cmd.ExecuteNonQuery();
                                reader.Close();
                                Conn.Close();
                            }
                        }
                    }

                }
                catch (Exception)
                {

                }
          //}

                #endregion
                ActivityTimer.Start();
                Processing = "Working";

        }

Unfortunately this is the result. it is not saving the data as I expect it to. What am i doing wrong I had thought that with the sql reader it would first check for a value and only save if they do not match however it is saving whether there is a match or not.